﻿CREATE PROCEDURE [dbo].[ContactDetail_Select]
@ContactDetailID uniqueidentifier
AS
BEGIN

SELECT [ContactDetailID]
, [CreatedDate]
, [CreatedBy]
, [ModifiedDate]
, [ModifiedBy]
, [Deleted]
, [HomeNumber]
, [MobileNumber]
, [WorkNumber]
, [FaxNumber]
, [EmailAddress]
FROM [dbo].[ContactDetail] (NoLock)
WHERE [Deleted] = 0
AND [ContactDetailID] = @ContactDetailID


END
